from django.db import models

class GuestInfo(models.Model):
    guest_id = models.AutoField(primary_key=True)
    guest_openid = models.CharField(max_length=50, blank=True, null=True)
    guest_unionid = models.CharField(unique=True, max_length=50, blank=True, null=True)
    guest_user_openid = models.CharField(max_length=50, blank=True, null=True)
    guest_about_house = models.CharField(max_length=50, blank=True, null=True)
    guest_about_house_id = models.IntegerField(blank=True, null=True)
    guest_about_building = models.CharField(max_length=50, blank=True, null=True)
    guest_about_building_id = models.IntegerField(blank=True, null=True)
    guest_name = models.CharField(max_length=50, blank=True, null=True)
    guest_nbr = models.CharField(max_length=50, blank=True, null=True)
    guest_phone = models.CharField(max_length=50, blank=True, null=True)
    guest_date1 = models.CharField(max_length=50, blank=True, null=True)
    guest_date2 = models.CharField(max_length=50, blank=True, null=True)
    guest_network_id = models.IntegerField(blank=True, null=True)
    guest_network_name = models.CharField(max_length=50, blank=True, null=True)
    guest_network_date = models.CharField(max_length=50, blank=True, null=True)
    guest_network_day = models.IntegerField(blank=True, null=True)
    guest_network_price = models.FloatField(blank=True, null=True)
    guest_network_price_type = models.IntegerField(blank=True, null=True)
    guest_price = models.FloatField(blank=True, null=True)
    guest_last_price = models.FloatField(blank=True, null=True)
    guest_balance = models.FloatField(blank=True, null=True)
    guest_electric_price = models.FloatField(blank=True, null=True)
    guest_last_electric_price = models.FloatField(blank=True, null=True)
    guest_water_price = models.FloatField(blank=True, null=True)
    guest_last_water_price = models.FloatField(blank=True, null=True)
    guest_start_date = models.CharField(max_length=50, blank=True, null=True)
    guest_price_type = models.IntegerField(blank=True, null=True)
    guest_electric_price_type = models.IntegerField(blank=True, null=True)
    guest_water_price_type = models.IntegerField(blank=True, null=True)
    guest_face_type = models.IntegerField(blank=True, null=True)

    class Meta:
        db_table = 'guest_info'